package com.oceanread.cn.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.oceanread.cn.entity.Drillhole1;
import com.oceanread.cn.entity.Turbine;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface Drillhole1Mapper extends BaseMapper<Drillhole1> {
    List<Drillhole1> getall();
    List<Drillhole1> getPrj(@Param("prjCode") String prjCode,@Param("start") int start, @Param("end") int end);
    Integer getPrjnum(@Param("prjCode") String prjCode);

    List<Drillhole1> query( @Param("key") String key, @Param("value") String value);

    List<Drillhole1> query1(@Param("start") int start, @Param("end") int end, @Param("key") String key, @Param("value") String value);
    Integer getnumquery(@Param("key")String key, @Param("value")String value);

    int insert(@Param("PrjCode") String PrjCode,
               @Param("Code") String Code,
               @Param("Name") String Name,
               @Param("PrjID") String PrjID,
               @Param("Type") String Type,
               @Param("Equipment") String Equipment,
               @Param("Lat") String Lat,
               @Param("Lon") String Lon,
               @Param("East") String East,
               @Param("North") String North,
               @Param("Sampling") String Sampling,
               @Param("Responsible") String Responsible,
               @Param("Drawing") String Drawing,
               @Param("Proofreading") String Proofreading,
               @Param("Catalog") String Catalog,
               @Param("Time") String Time,
               @Param("Diameter") String Diameter,
               @Param("Altitude") String Altitude,
               @Param("Start") String Start,
               @Param("Thickness") String Thickness,
               @Param("Material") String Material,
               @Param("Material0") String Material0
               );
    Integer delete(@Param("id") int id);
    Integer update(@Param("id") int id,
                   @Param("PrjCode") String PrjCode,
                   @Param("Code") String Code,
                   @Param("Name") String Name,
                   @Param("PrjID") String PrjID,
                   @Param("Type") String Type,
                   @Param("Equipment") String Equipment,
                   @Param("Lat") String Lat,
                   @Param("Lon") String Lon,
                   @Param("East") String East,
                   @Param("North") String North,
                   @Param("Sampling") String Sampling,
                   @Param("Responsible") String Responsible,
                   @Param("Drawing") String Drawing,
                   @Param("Proofreading") String Proofreading,
                   @Param("Catalog") String Catalog,
                   @Param("Time") String Time,
                   @Param("Diameter") String Diameter,
                   @Param("Altitude") String Altitude,
                   @Param("Start") String Start,
                   @Param("Thickness") String Thickness,
                   @Param("Material") String Material,
                   @Param("Material0") String Material0
    );
}
